 

 
alter view [dbo].[vwCGoodsAndEGoods]
as
 select distinct b.CorpCode AS CorpCodeCV,b.CorpCopGNo AS CorpCopGNoCV,b.CopGName  AS CopGNameCV,b.CopGModel AS CopGModelCV,
b.ErpUnit AS ErpUnitCV,b.ErpPrice AS ErpPriceCV,b.ErpFactorWt AS ErpFactorWtCV,b.ErpCurr  AS ErpCurrCV,c.TransRate,a.* 
 from EpGoodsMr  as a 
 left  join CustomerGoodsRefer as c on a.CopGNo=c.CopGNo
 left  join CustomerGoods as b on c.CorpCopGNo = b.CorpCopGNo
 



GO


 


alter view [dbo].[vwVGoodsAndEGoods]
as
 select distinct b.CorpCode AS CorpCodeCV,b.CorpCopGNo AS CorpCopGNoCV,b.CopGName  AS CopGNameCV,b.CopGModel AS CopGModelCV,
b.ErpUnit AS ErpUnitCV,b.ErpPrice AS ErpPriceCV,b.ErpFactorWt AS ErpFactorWtCV,b.ErpCurr  AS ErpCurrCV,c.TransRate,a.* 
 from EpGoodsMr  as a 
 left  join VendorrGoodsRefer as c on a.CopGNo=c.CopGNo
 left  join VendorGoods as b on c.CorpCopGNo = b.CorpCopGNo
 


GO


